Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# LIMIT BASEDIMS

The LIMIT BASEDIMS command sets the current status list of one or more base dimensions of a composite, conjoint dimension, concat dimension, or a partition template based on the selected values of that object. You can also use the LIMIT BASEDIMS command to assign a value to one or more valuesets for the base dimensions.

Values that are in the current status list of a dimension are said to be "in status." The status of the base dimensions of a composite, conjoint dimension, concat dimension, or a partition template is determined by the current status of its base dimensions.

See also: For more information on working with dimension status, see "Making Selections and Working with Subsets of Data" and. "LIMIT command".

Syntax

LIMIT BASEDIMS [dimlist] TO object [ [KEEP] limit-clause ]

Arguments

dimlist

  A space-delimited list of objects that identifies the base dimensions for which you want Oracle OLAP to change status and the valuesets for which you want Oracle OLAP to add values. Within dimlist, you can specify the following values:

    base-dimension-name
    The name of a base dimension of object.
    relation-name
    The name of a relation. When you specify a relation, Oracle OLAP sets the status of the related dimension.
    valueset-name
    The name of a valueset for a base dimension. When you specify the name of a valueset, Oracle OLAP assigns a single value to the specified valueset.

  The default value of dimlist is the completely expanded list of the base dimensions of object.

object

  The name of a composite, a conjoint dimension, a concat dimension, or a partition template object.

KEEP

  Specifies that Oracle OLAP performs the selection based on the current dimension status of the base dimensions of the object. KEEP preserves the current order of values among the values that remain in the status.

limit-clause

  Specifies how Oracle OLAP should select values from object to modify the current status lists of the base dimensions. You can specify any of the non-positional limit clauses described for the LIMIT command. For the syntax of these clauses, see:

    LIMIT command (using values)
    LIMIT command (using LEVELREL)
    LIMIT command (using related dimension)
    LIMIT command (using parent relation)
    LIMIT command (NOCONVERT)

  When this optional argument is not specified, Oracle OLAP sets the status of the base dimensions to the current status of the dimensions.